package com.lms.dao.lab;

import com.lms.bean.LabData;
import com.lms.bean.LabWeek;
import com.lms.pojo.LabIntervalData;
import com.lms.util.Constants;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface LabDao {
    List<LabData> getLabList(Connection connection) throws SQLException;
    LabWeek getLabWeekByLabName(Connection connection,String LabCode,String week)throws SQLException;
    int getLabTotal(Connection connection,String labCode) throws SQLException;
    int getApplyCount(Connection connection,String labCode,String week,String interval) throws SQLException;
    LabData getLabDataByLabCode(Connection connection, String labCode) throws SQLException;
    List<LabIntervalData> getLabIntervalData(Connection connection,String week,String interval) throws SQLException;
    String getLabCodeByLabName(Connection connection,String labName) throws SQLException;
    LabData getLabDataByLabName(Connection connection,String labName) throws SQLException;
    int labModify(Connection connection,String labName, String labTotal, String labTag, String labIntroduce) throws SQLException;
}
